package com.bjwl.display.mapper.safty;

import com.bjwl.display.model.Role;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RoleMapper {
    //通过ro_id获取角色信息;
    @Select("select * from sys_role where ro_id=#{ro_id}")
    Role queryRoleByRoId(Integer ro_id);

    //通过ro_id获取模块信息,并且模块状态为1
    @Select("select rm.m_id from sys_rm rm inner join sys_module m on rm. m_id=m.m_id where rm.ro_id=#{ro_id} and m.m_ismenu=1")
    List<Integer> queryMoIdByRoId(Integer ro_id);




}
